Tables [dbo].[Affect_Cert_Register_ie]
Properties
PropertyValue
HeapYes
Row Count0
Created10:31:13 AM Tuesday, March 02, 2010
Last Modified10:31:13 AM Tuesday, March 02, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
SEQNint4
No
((0))
STUDENT_IDvarchar(10)10
No
('')
BT_IDvarchar(10)10
No
('')
SQL Script
CREATE TABLE [dbo].[Affect_Cert_Register_ie]
(
[SEQN] [int] NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_SEQN] DEFAULT ((0)),
[STUDENT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_STUDENT_ID] DEFAULT (''),
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_BT_ID] DEFAULT ('')
) ON [PRIMARY]

GO
Uses